Visualise postgres database schema using schemaspy

Download the .jar file for schemaspy, the JRE, JDBC and graphviz (check latest versions):

$ wget https://github.com/schemaspy/schemaspy/releases/download/v6.1.0/schemaspy-6.1.0.jar
$ wget https://jdbc.postgresql.org/download/postgresql-42.2.14.jar
$ sudo apt install default-jre graphviz

Run schemaspy with the salient parameters:

$ java -jar ./schemaspy-6.1.0.jar -t pgsql -db [database] -host [host]:[port] -u [username] -p [password] -o ./schemaspy -dp ./postgresql-42.2.14.jar -s [schema_name] -noads

Output in /schemaspy/diagrams/summary.